Release 10.1A: OpenEdge Development:
ADM Reference
fetchRowIdent
Repositions the RowObject’s query to the desired row, based on the corresponding database record ROWID as specified by pcRowIdent and returns values for the rows as specified in pcViewColList. The return value is a CHR(1)-delimited list of values that are formatted according to the FORMAT expression for each column. The first value in the list is the RowIdent of the fetched row. If that row is not in the RowObject table, it repositions the database query to that row and resets the RowObject table.
Location: data.p Parameters:INPUT pcRowIdent AS CHARACTERThe desired rowids within the result set, expressed as a comma-separated list of database rowids.
INPUT pcViewColList AS CHARACTERComma-separated list of names of columns to be returned.
Returns: CHARACTER Notes:
- If called with unknown or nonexisting rowid, the query is closed and the SDO fetchNext and Prev do not work. The application needs to call fetchRowident with a valid value or fetchFirst, fetchLast, or openQuery to get back to normal.
- This method resolves the row reposition on the server. As a result, the SDO can no longer determine whether the row position is invalid until after the request has been executed. However, if the RebuildOnRepos property is set to TRUE, the temp-table is emptied before the request.
- The current behavior for a FIND that does not find anything when RebuildOnRepos is TRUE is to read the current batch again.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |